set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区
insert overwrite table jms_dwd.dwd_tab_customer_monitor_deploy_dt partition(dt)
select
project_custom_id
,project_custom_name
,mill_id
,agent_num
,franchisee_num
,network_num
,mill_type
,update_time
,update_by
,dt
from jms_ods.tab_customer_monitor_deploy
where dt = '{{ execution_date | cst_ds }}';
